Introduction

You can benefit from moving towards a multi-sever application setup by separating your application servers and database servers. PostgreSQL is an extremely popular database server used in production for a large number of applications on the web. phpPgAdmin is an additional package that allows access to PostgreSQL via a web-based graphical interface. Stack Harbor has made it simple for your to get started managing a database server using our turnkey Stacks. In this tutorial we’ll show you how to access your PostgreSQL and phpPgAdmin Stack once you’ve built it using our Cloud Management Interface.

Logging In

Once you’ve built your stack, point your browser to http://your_ip_address/phppgadmin. You’ll be asked for access credentials by apache. You can find your username and password by logging into your machine using SSH. If you don’t know how to access your Stack using SSH, check out our “Getting Started with Your Stack” tutorial. Both your apache credentials and your PostgreSQL credentials will be shown in the message of the day (MOTD).

Once you’ve logged into your server using SSH, you’ll find that a block of text has been logged to your terminal. This is called the message of the day (MOTD) and contains all sensitive information including database administrative and root passwords, as well as the apache credentials needed earlier. Using the first set of credentials, authenticate with the popup apache login. Once you’ve authenticated with apache, click the PostgreSQL link shown on the left hand side of the interface. Here, you’ll be prompted for Postgres authentication information. Use the ‘admin’ account (second set of credentials in the MOTD) to login here.

Final Words

The web interface of phpPgAdmin allows you to explore all the information in your database without having to write complex SQL queries from the command line. You’re all set to start manipulating your data and extracting important information from it. Check out our Community Section for more tutorials on databases and other server administration tasks. From us at Stack Harbor, ahoy!